package com.chinasoft.movies.mapper;

import com.chinasoft.movies.pojo.GenreMoviesPie;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface GenreMoviesPieMapper {
    @Select("select genre,sum(movie_count) as count from genre_percentage_by_vote where vote between 8 and 10 group by genre")
    List<GenreMoviesPie> queryAllGenreMoviesPie();

}
